/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 80028
 Source Host           : 127.0.0.1:3306
 Source Schema         : course_share

 Target Server Type    : MySQL
 Target Server Version : 80028
 File Encoding         : 65001

 Date: 12/07/2022 23:46:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for alembic_version
-- ----------------------------
DROP TABLE IF EXISTS `alembic_version`;
CREATE TABLE `alembic_version` (
  `version_num` varchar(32) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`version_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of alembic_version
-- ----------------------------
BEGIN;
INSERT INTO `alembic_version` (`version_num`) VALUES ('5e852d198e6d');
COMMIT;

-- ----------------------------
-- Table structure for cs_contents
-- ----------------------------
DROP TABLE IF EXISTS `cs_contents`;
CREATE TABLE `cs_contents` (
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `contents_name` varchar(32) COLLATE utf8_bin NOT NULL,
  `contents_level` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cs_contents
-- ----------------------------
BEGIN;
INSERT INTO `cs_contents` (`create_time`, `update_time`, `id`, `contents_name`, `contents_level`) VALUES ('2022-04-09 00:10:50', '2022-06-04 20:17:21', 1, '一级目录01', 0);
INSERT INTO `cs_contents` (`create_time`, `update_time`, `id`, `contents_name`, `contents_level`) VALUES ('2022-04-09 00:11:07', '2022-06-04 01:19:20', 2, '二级目录01', 1);
INSERT INTO `cs_contents` (`create_time`, `update_time`, `id`, `contents_name`, `contents_level`) VALUES ('2022-04-30 16:53:52', '2022-06-04 20:07:04', 3, '二级目录02', 1);
INSERT INTO `cs_contents` (`create_time`, `update_time`, `id`, `contents_name`, `contents_level`) VALUES ('2022-04-30 19:13:42', '2022-04-30 19:13:42', 4, '一级目录03', 0);
INSERT INTO `cs_contents` (`create_time`, `update_time`, `id`, `contents_name`, `contents_level`) VALUES ('2022-04-30 19:14:11', '2022-04-30 19:14:11', 5, '一级目录04', 0);
INSERT INTO `cs_contents` (`create_time`, `update_time`, `id`, `contents_name`, `contents_level`) VALUES ('2022-04-30 19:14:14', '2022-04-30 19:14:14', 6, '一级目录05', 0);
INSERT INTO `cs_contents` (`create_time`, `update_time`, `id`, `contents_name`, `contents_level`) VALUES ('2022-04-30 19:14:17', '2022-04-30 19:14:17', 7, '一级目录06', 0);
COMMIT;

-- ----------------------------
-- Table structure for cs_course
-- ----------------------------
DROP TABLE IF EXISTS `cs_course`;
CREATE TABLE `cs_course` (
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `contents_id` int NOT NULL,
  `label_id` int NOT NULL,
  `title` varchar(64) COLLATE utf8_bin NOT NULL,
  `normal_price` int DEFAULT NULL,
  `vip_price` int DEFAULT NULL,
  `introduce` text COLLATE utf8_bin NOT NULL,
  `contents` text COLLATE utf8_bin NOT NULL,
  `index_image_url` varchar(256) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cs_course
-- ----------------------------
BEGIN;
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 10, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:10:16', '2022-06-13 23:10:16', 11, 6, 3, '西瓜视频', 399, 199, '西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频', '西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频西瓜视频', 'FnqXupxZR-jLWwHxYKySZv6QbcXh');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:10:54', '2022-06-13 23:10:54', 12, 6, 2, '快手视频', 799, 299, '快手视频快手视频快手视频快手视频快手视频快手视频', '快手视频快手视频快手视频快手视频快手视频快手视频快手视频快手视频快手视频快手视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:11:28', '2022-06-13 23:11:28', 13, 5, 7, '腾讯视频', 499, 399, '腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频', '腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频腾讯视频', 'FsffCrGEF8l3YKHQsobcjZd2s9VE');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:12:05', '2022-06-13 23:12:05', 14, 7, 8, '抖音视频火山版', 399, 189, '抖音视频火山版抖音视频火山版抖音视频火山版抖音视频火山版抖音视频火山版', '抖音视频火山版抖音视频火山版抖音视频火山版抖音视频火山版抖音视频火山版抖音视频火山版抖音视频火山版', 'FnqXupxZR-jLWwHxYKySZv6QbcXh');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:17:40', '2022-06-13 23:17:40', 15, 1, 1, '网易云课堂', 399, 199, '网易云课堂网易云课堂网易云课堂网易云课堂', '网易云课堂网易云课堂网易云课堂网易云课堂网易云课堂网易云课堂', 'FnqXupxZR-jLWwHxYKySZv6QbcXh');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 16, 1, 7, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 17, 1, 7, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 18, 1, 7, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 19, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 20, 1, 7, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 21, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 22, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 23, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 24, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 25, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 26, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
INSERT INTO `cs_course` (`create_time`, `update_time`, `id`, `contents_id`, `label_id`, `title`, `normal_price`, `vip_price`, `introduce`, `contents`, `index_image_url`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 27, 1, 1, '抖音视频', 1999, 999, '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', '抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频抖音视频', 'FpRvwtA3EP8Nmmocwnsm8QXu79al');
COMMIT;

-- ----------------------------
-- Table structure for cs_image
-- ----------------------------
DROP TABLE IF EXISTS `cs_image`;
CREATE TABLE `cs_image` (
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `course_id` int NOT NULL,
  `screenshot_url` varchar(256) COLLATE utf8_bin NOT NULL,
  `is_index_img` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cs_image
-- ----------------------------
BEGIN;
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:05:34', '2022-06-13 23:05:34', 21, 9, 'FpRvwtA3EP8Nmmocwnsm8QXu79al', 1);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 22, 10, 'FpRvwtA3EP8Nmmocwnsm8QXu79al', 1);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 23, 10, 'FmwdZFnYhXx4-oRkC17_z1PMeKLf', 2);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:09:43', '2022-06-13 23:09:43', 24, 10, 'FsffCrGEF8l3YKHQsobcjZd2s9VE', 2);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:10:16', '2022-06-13 23:10:16', 25, 11, 'FnqXupxZR-jLWwHxYKySZv6QbcXh', 1);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:10:54', '2022-06-13 23:10:54', 26, 12, 'FpRvwtA3EP8Nmmocwnsm8QXu79al', 1);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:11:28', '2022-06-13 23:11:28', 27, 13, 'FsffCrGEF8l3YKHQsobcjZd2s9VE', 1);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:12:05', '2022-06-13 23:12:05', 28, 14, 'FmwdZFnYhXx4-oRkC17_z1PMeKLf', 1);
INSERT INTO `cs_image` (`create_time`, `update_time`, `id`, `course_id`, `screenshot_url`, `is_index_img`) VALUES ('2022-06-13 23:17:40', '2022-06-13 23:17:40', 29, 15, 'FnqXupxZR-jLWwHxYKySZv6QbcXh', 1);
COMMIT;

-- ----------------------------
-- Table structure for cs_label
-- ----------------------------
DROP TABLE IF EXISTS `cs_label`;
CREATE TABLE `cs_label` (
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `label_name` varchar(32) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cs_label
-- ----------------------------
BEGIN;
INSERT INTO `cs_label` (`create_time`, `update_time`, `id`, `label_name`) VALUES ('2022-04-09 00:19:41', '2022-05-10 23:31:07', 1, '抖音标签');
INSERT INTO `cs_label` (`create_time`, `update_time`, `id`, `label_name`) VALUES ('2022-05-10 23:12:57', '2022-06-04 20:07:30', 2, '快手-修改');
INSERT INTO `cs_label` (`create_time`, `update_time`, `id`, `label_name`) VALUES ('2022-05-10 23:13:05', '2022-05-10 23:37:06', 3, '西瓜视频-改');
INSERT INTO `cs_label` (`create_time`, `update_time`, `id`, `label_name`) VALUES ('2022-06-04 01:18:23', '2022-06-04 01:18:43', 6, '抖音标签0234');
INSERT INTO `cs_label` (`create_time`, `update_time`, `id`, `label_name`) VALUES ('2022-06-04 20:15:40', '2022-06-04 20:15:51', 7, '标签修改');
INSERT INTO `cs_label` (`create_time`, `update_time`, `id`, `label_name`) VALUES ('2022-06-04 20:18:04', '2022-06-04 20:18:12', 8, '快手视频-修改');
COMMIT;

-- ----------------------------
-- Table structure for cs_order
-- ----------------------------
DROP TABLE IF EXISTS `cs_order`;
CREATE TABLE `cs_order` (
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `user_id` int NOT NULL,
  `course_id` int NOT NULL,
  `order_price` int NOT NULL,
  `order_status` enum('WAIT_PAYMENT','PAID','COMPLETE','CANCELED') COLLATE utf8_bin DEFAULT NULL,
  `trade_no` varchar(80) COLLATE utf8_bin DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `ix_cs_order_order_status` (`order_status`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cs_order
-- ----------------------------
BEGIN;
INSERT INTO `cs_order` (`create_time`, `update_time`, `id`, `user_id`, `course_id`, `order_price`, `order_status`, `trade_no`) VALUES ('2022-04-12 23:53:53', '2022-04-13 00:03:43', 1, 1, 1, 2999, 'CANCELED', NULL);
COMMIT;

-- ----------------------------
-- Table structure for cs_panshare
-- ----------------------------
DROP TABLE IF EXISTS `cs_panshare`;
CREATE TABLE `cs_panshare` (
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `course_id` int NOT NULL,
  `share_url` varchar(256) COLLATE utf8_bin NOT NULL,
  `share_code` varchar(10) COLLATE utf8_bin NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cs_panshare
-- ----------------------------
BEGIN;
INSERT INTO `cs_panshare` (`create_time`, `update_time`, `id`, `course_id`, `share_url`, `share_code`) VALUES ('2022-04-14 23:23:08', '2022-06-03 00:40:03', 1, 1, 'http://127.0.0.1:5000/api/v1.0/add_panshare', '4567');
INSERT INTO `cs_panshare` (`create_time`, `update_time`, `id`, `course_id`, `share_url`, `share_code`) VALUES ('2022-06-03 00:40:30', '2022-06-04 01:33:12', 3, 3, 'http://127.0.0.1:5000/api/v1.0/234324324324', '34534456');
INSERT INTO `cs_panshare` (`create_time`, `update_time`, `id`, `course_id`, `share_url`, `share_code`) VALUES ('2022-06-04 01:33:20', '2022-06-04 01:33:20', 4, 5, 'http://127.0.0.1:5000/api/v1.0/add_panshare', '456456456');
INSERT INTO `cs_panshare` (`create_time`, `update_time`, `id`, `course_id`, `share_url`, `share_code`) VALUES ('2022-06-04 20:09:06', '2022-06-04 20:09:06', 5, 7, 'http://127.0.0.1:5000/api/v1.0/2343243234324', '2845');
INSERT INTO `cs_panshare` (`create_time`, `update_time`, `id`, `course_id`, `share_url`, `share_code`) VALUES ('2022-06-04 20:19:39', '2022-06-04 20:19:39', 6, 8, 'http://127.0.0.1:5000/api/v1.0/add_panshare', '345435');
COMMIT;

-- ----------------------------
-- Table structure for cs_user
-- ----------------------------
DROP TABLE IF EXISTS `cs_user`;
CREATE TABLE `cs_user` (
  `create_time` datetime DEFAULT NULL,
  `update_time` datetime DEFAULT NULL,
  `id` int NOT NULL AUTO_INCREMENT,
  `user_name` varchar(32) COLLATE utf8_bin NOT NULL,
  `password_hash` varchar(128) COLLATE utf8_bin NOT NULL,
  `mail` varchar(32) COLLATE utf8_bin NOT NULL,
  `avatar_url` varchar(128) COLLATE utf8_bin DEFAULT NULL,
  `is_vip` int DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `mail` (`mail`),
  UNIQUE KEY `user_name` (`user_name`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb3 COLLATE=utf8_bin;

-- ----------------------------
-- Records of cs_user
-- ----------------------------
BEGIN;
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-09 00:08:05', '2022-04-09 00:10:35', 1, 'admin', 'pbkdf2:sha256:260000$Blzznhj2SO9ZsNNX$602b843a2678e439039790d596c3221e0599dccf866168a852e3e44fb86df72d', 'caoting0403@163.com', 'FnqXupxZR-jLWwHxYKySZv6QbcXh', 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-21 22:05:28', '2022-04-21 22:05:28', 2, 'awpht01', 'pbkdf2:sha256:260000$X2UF039xqEWUYgNi$b33c3898d46349197877ee89fceb6f5739d9b35bcb1cf9017faddb3a4b6ec4dc', 'caoting01@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-21 22:05:35', '2022-04-21 22:05:35', 3, 'awpht02', 'pbkdf2:sha256:260000$wsXfmiUIdEztrXKN$9b6fffa9832ab948b9c44acbf7ce0d8370aec1a16bba986315247b166681c98b', 'caoting02@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:19:46', '2022-04-26 23:19:46', 4, 'awpht03', 'pbkdf2:sha256:260000$jvwOWgsnOuV1vLkE$ca7e2494cedae81857d661bb1d80a67c8c484d797eaff49c5549043e4c442fb3', 'caoting03@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:19:53', '2022-04-26 23:19:53', 5, 'awpht04', 'pbkdf2:sha256:260000$Me43f2uGjY63Ix5g$f8ad7d16723563ff80ea442ebdb38d8f3935f7d029e7c12560fbaf9093313877', 'caoting04@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:00', '2022-04-26 23:20:00', 6, 'awpht05', 'pbkdf2:sha256:260000$xMTkhUaBnAY1QqcL$362509eb77142b5c5b428ce832a21ddf48f3939d0c31b01a538b1a6cccfb60c3', 'caoting05@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:05', '2022-04-26 23:20:05', 7, 'awpht06', 'pbkdf2:sha256:260000$yLtjOGyp5TG22kar$e3866cc45e57ae52b291b6613181c3e4e656b98973a5ee0d7fccb01de9ebdcf9', 'caoting06@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:11', '2022-04-26 23:20:11', 8, 'awpht07', 'pbkdf2:sha256:260000$bHhzAylHIe3xjak9$4618b9ca815f7656dc9d2a0e855e0a86894ca2515d58d69c3785832cfcb2ac1f', 'caoting07@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:16', '2022-04-26 23:20:16', 9, 'awpht08', 'pbkdf2:sha256:260000$mKSEvYFffK5kdCzS$da240d15977a920b8473014ce0261be44dc18822b0fd3251c7afd2a7c593477c', 'caoting08@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:25', '2022-04-26 23:20:25', 10, 'awpht09', 'pbkdf2:sha256:260000$C7E7WtoInUh1Kol3$5430e3c0c41c0780fca6bb62b054450986fd1eb0b84fa0686e3565b94b835e65', 'caoting09@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:33', '2022-04-26 23:20:33', 11, 'awpht10', 'pbkdf2:sha256:260000$1m29prDe9sGPNKCH$2aa5396bac21e7b81e4cdfc04a33789035062375126598215eaadc962962bbbc', 'caoting10@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:39', '2022-04-26 23:20:39', 12, 'awpht11', 'pbkdf2:sha256:260000$2fjq9OEXlLOFqVtf$82ade15d0d7a11c802e329bd9d02318dde0394eac1b9345a05981089819711ef', 'caoting11@163.com', NULL, 2);
INSERT INTO `cs_user` (`create_time`, `update_time`, `id`, `user_name`, `password_hash`, `mail`, `avatar_url`, `is_vip`) VALUES ('2022-04-26 23:20:44', '2022-04-26 23:20:44', 13, 'awpht12', 'pbkdf2:sha256:260000$wW2NLZudYVtPm51i$8949e4909c4c8b81212ec3a00755bbd7d200bfeba32a5e34b332f73a65f09929', 'caoting12@163.com', NULL, 2);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
